- More about the SQL::Connection Object
/documentation/pages/Ref/Api/Namespace/SQL/Connection/More about the SQL Connection Object.xml
While working in the Interactive window, after creating the conn SQL::Connection object, you could type.
- Executing a SQL Query with the SQL::Connection Object
/documentation/pages/Server/Reference/Design/Data/SQL/Executing a SQL Query with the SQL Connection Object.xml
Return to the Interactive window and open a new connection to AlphaSports.MDB.
- SQL::Connection ToGridComponentDataObject Method
/documentation/pages/Ref/Api/Namespace/SQL/Connection/ToGridComponentDataObject Method.xml
Fetch data to a Grid Component Data Object using a SQL Query.
- SQL::Connection ClearSchemaCache Method
/documentation/pages/Ref/Api/Namespace/SQL/Connection/ClearSchemaCache Method.xml
Clear any schema data cached by the connection.
- SQL::Connection CommitTransaction Method
/documentation/pages/Ref/Api/Namespace/SQL/Connection/CommitTransaction Method.xml
Apply a set of changes started with BeginTransaction.
- SQL::Connection DropDatabase Method
/documentation/pages/Ref/Api/Namespace/SQL/Connection/DropDatabase Method.xml
Remove a database.
- SQL::Connection ListDatabases Method
/documentation/pages/Ref/Api/Namespace/SQL/Connection/ListDatabases Method.xml
Return a list of databases from the current server.
- SQL::Connection ListServers Method
/documentation/pages/Ref/Api/Namespace/SQL/Connection/ListServers Method.xml
Return a list of servers for the current connection Application Programming Interface(API).
- SQL::Connection CreateIndex Method
/documentation/pages/Ref/Api/Namespace/SQL/Connection/CreateIndex Method.xml
Create an index on the specified table in the currently connected database using the TableInfo and IndexInfo specifications.
- SQL::Connection Open Method
/documentation/pages/Ref/Api/Namespace/SQL/Connection/Open Method.xml
Connect to a database. (See help for SetConnectionString for details on constructing a connect string.)